 
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spSuppliersGetListAll]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spSuppliersGetListAll]
GO

	
CREATE PROCEDURE spSuppliersGetListAll

AS

SELECT
	[Suppliers].[SupplierCode],
	('['+ConPoints.[Description] + ']/' + [SupplierName]) AS [SupplierName],
	Suppliers.[ConPointID],
	[IsArchived]
FROM [Suppliers] LEFT JOIN ConPoints ON [Suppliers].ConpointID = ConPoints.ConpointID
ORDER BY [Suppliers].[SupplierCode],[Suppliers].ConpointID
GO

	
